﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE proc_Statistics_Financial_RBMX
	(
	@CompanyId INT ,
	@TDate	varchar(10),
	@flag int
	)
AS
BEGIN
	
	Declare @sRq Datetime,@eRq Datetime
	Set @sRq = Convert(Datetime, Convert(varchar(10),@TDate,120) + ' 00:00:00')
	Set @eRq = Convert(Datetime, Convert(varchar(10),@TDate,120) + ' 23:59:59')

    select * from bankye where companyid=@CompanyId and flag=@flag and [date] between @sRq and @eRq
    
END
